package com.ctshk.rpc.scenic.mapper.app;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ctshk.rpc.scenic.dto.app.ScenicProductTypeDTO;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface ScenicProductTypeMapper extends BaseMapper<ScenicProductTypeDTO> {
    @Select("SELECT DISTINCT  " +
            "`ctshk-cloud`.t_scenic_product_type_icon.id AS id,   " +
            "`ctshk-cloud`.t_scenic_product_type_icon.`name` AS `name`,   " +
            "`ctshk-cloud`.t_scenic_product_type_icon.photos AS photos,   " +
            "`ctshk-cloud`.t_scenic_product_type_icon.`status` AS `status`  " +
            "FROM  " +
            "`ctshk-cloud`.t_scenic_product_type_icon  " +
            "WHERE `ctshk-cloud`.t_scenic_product_type_icon.status = 0")
    List<ScenicProductTypeDTO> selectScenicProductTypeList();
}
